Data Stores

In 1Integrate, a data store describes where some external spatial data is being read from or written to.

This represents the data which will be analysed by Rules and Actions within 1Integrate.

The data store can be:

• Automatically supported formats such as Oracle Spatial databases (with or without workspaces enabled), Esri Shapefile, MapInfo Tab files.

• Other data formats via an FME Desktop integration (requires an FME Desktop licence).

  Formats available include file formats (e.g. Bentley DGN) and database formats (e.g. PostGIS). See Supported Data Store Types.

• Other data formats available via project-specific bespoke data stores.

When running a session using a data store, the data is stored in the cache (see Session Cache).

Note: Names of classes and properties in 1Integrate can contain any ISO 8859 characters. Unicode is not supported.

Note: All lengths, areas, and co-ordinates used in 1Integrate are in dataset units (the co-ordinate system used in the external data source). 1Integrate does not perform any automatic co-ordinate conversions.

Supported Data Store Types

1Integrate supports the following types of datastores for input (reading) and output (writing), either as standard or using FME Desktop (which requires a licence). Pay particular attention to the prerequisites attached to certain datastore types:

Note: All formats listed below as using FME Desktop require FME Desktop Professional Edition, unless otherwise indicated.

Data Store Type	As standard		Using FME Desktop
	Read	Write	Read	Write
Bentley Microstation Design (V8)
Comma Separated Value (CSV)
Autodesk AutoCAD DWG/DXF
Esri Enterprise Geodatabase			1 This format is only available on Windows. Requires FME Desktop (64-bit) Esri Edition, and ArcGIS Desktop, ArcGIS Desktop Background Processing (64-bit) and Database client (64-bit).	2This format is only available on Windows. Requires FME Desktop (64-bit) Esri Edition, and ArcGIS Desktop, ArcGIS Desktop Background Processing (64-bit) and Database client (64-bit).
Esri File Geodatabase
Esri Shapefile
MapInfo Tab
Microsoft SQL Server Spatial				3Requires FME Desktop Database Edition.
Oracle
PostGIS

Commit / Copy-To Support

Not all data store types support the Commit task as a method of writing data back to a data store (see Commit Task). However, all data store types support the Copy-To task (see Copy To Task).

Data Store Type	Task Supported
	Commit	Copy-To
Bentley Microstation Design (V8)
Comma Separated Value (CSV)
Autodesk AutoCAD DWG/DXF
Esri Enterprise Geodatabase
Esri File Geodatabase
Esri Shapefile
MapInfo Tab
Microsoft SQL Server Spatial
Oracle
PostGIS